Is there any way to import a spreadsheet and keep the correct format so that all of the levels of text are shown correctly? I know it is possible to import a spreadsheet, but I cannot figure out how to make a spreadsheet which is formatted almost exactly like an RTF to look correct when it has been imported. I am using different levels within the spreadsheet, but no attribute columns. Is there any way to get around this and import it in a formatted state?
Thanks!
josiah820 - Mon Jul 16 15:18:11 EDT 2012 |
|
Re: Import Spreadsheet
rmoskwa - Tue Jul 17 12:58:44 EDT 2012
I am not sure as to what you mean when you say "I am using different levels within the spreadsheet, but no attribute columns." How are you implementing different levels in the spreadsheet?
Are you talking about Heading Numbers?
Are you talking about space indents, or tab indents?
Are you using different columns to imply a level?
I am having trouble visualizing what your spreadsheet looks like.
Perhaps the attached doc might help you.
Attachments
attachment_14865164_doors_tech_tip_-_importing_spreadsheets.doc
|
|
Re: Import Spreadsheet
josiah820 - Wed Jul 18 10:12:01 EDT 2012 rmoskwa - Tue Jul 17 12:58:44 EDT 2012
I am not sure as to what you mean when you say "I am using different levels within the spreadsheet, but no attribute columns." How are you implementing different levels in the spreadsheet?
Are you talking about Heading Numbers?
Are you talking about space indents, or tab indents?
Are you using different columns to imply a level?
I am having trouble visualizing what your spreadsheet looks like.
Perhaps the attached doc might help you.
Thanks!
|
|
Re: Import Spreadsheet
josiah820 - Wed Jul 18 10:13:46 EDT 2012 josiah820 - Wed Jul 18 10:12:01 EDT 2012
Here is the file from which I am taking the templates. There are three different types of files (one on each page of the book.) I tried saving each page as a seperate .csv file so that I could import it into DOORS, but (as you can see if you try it,) it is formatted REALLY weird, and some of the text just doesn't show up. It seems to almost randomly choose what it imports into DOORS. I'm not sure what's up. Is there any way to possibly import a file of one of these types into DOORS?
Thanks!
|
|
Re: Import Spreadsheet
josiah820 - Wed Jul 18 10:16:09 EDT 2012 josiah820 - Wed Jul 18 10:13:46 EDT 2012
The file didn't attach...
Thanks!
Attachments
attachment_14865522_Copy_of_Liens_Recoveries_TPL_Templates_0.zip
|
|
Re: Import Spreadsheet
Craig_Cordrey - Wed Jul 18 10:43:34 EDT 2012 josiah820 - Wed Jul 18 10:16:09 EDT 2012
Let's try this... I put all of the files (the original .xlsx file, and the .csv files) into this zip folder. Maybe it will upload this time.
Thanks!
Every row in a CSV file is imported into DOORS as a separate object.
In each row, each cell is matched to an attribute.
How are you defining the attributes that the text is being imported into? Normally, the names of these attributes are defined in the first line of the CSV file.
Since the first row of your CSV file has no text in it, DOORS raises a number of warning dialog boxes and then when I press ahead I get a DXL error.
If you are specifying the names of attributes to import the CSV into, then you need to be aware that the text does not always appear in the same column of the CSV and therefor will not always appear in the same attribute of your module.
I tried setting all 29 labels to import to Object Text, but I ended up with a load of empty objects, presumably because each column in each row overwrote the last and the 29 column is always blank.
This looks like a prime example of where one shouldn't try to write 'documents' in Excel. That's what Word is for!
|
|
Re: Import Spreadsheet
josiah820 - Wed Jul 18 12:02:53 EDT 2012 Craig_Cordrey - Wed Jul 18 10:43:34 EDT 2012
Josiah,
Every row in a CSV file is imported into DOORS as a separate object.
In each row, each cell is matched to an attribute.
How are you defining the attributes that the text is being imported into? Normally, the names of these attributes are defined in the first line of the CSV file.
Since the first row of your CSV file has no text in it, DOORS raises a number of warning dialog boxes and then when I press ahead I get a DXL error.
If you are specifying the names of attributes to import the CSV into, then you need to be aware that the text does not always appear in the same column of the CSV and therefor will not always appear in the same attribute of your module.
I tried setting all 29 labels to import to Object Text, but I ended up with a load of empty objects, presumably because each column in each row overwrote the last and the 29 column is always blank.
This looks like a prime example of where one shouldn't try to write 'documents' in Excel. That's what Word is for!
|
|